Accounts payable
File layout
- Recommend the file name begin with “AP_”
- Example: AP_Actual2020_JAN
-
Each month should have a file, and each file should have a unique file name.
Field | Description | Field Type | Length |
---|---|---|---|
Entity | Entity or Hospital Identification Code | Numeric | 5 |
Dept | Department or Cost Center Number | Numeric | 10 |
Acct | GL Account Number | Numeric | 10 |
Vendor Number | Vendor Number | Text | 25 |
Vendor Name | Vendor Name | Text | 50 |
PONum | Purchase Order Number | Text | 25 |
ItemNoDesc | Item\Line Number Description | Text | 100 |
InvoiceNum | Invoice Number | Text | 50 |
Amount | Dollar Amount | Decimal | 11.2 |
CheckNo | Check Number | Text | 25 |
VendorImageLink | URL to vendor image location | Text | 1000 |
Sample file layout